Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIFS Issue
I'm trying to do a sumifs with two criteria. Below is my data and equation.
ID COUNT SUM FIRST 4 LAST 2 010100 1 $40,000.00 0101 00 010101 7 $194,230.00 0101 01 010102 2 $60,000.00 0101 02 010201 4 $120,000.00 0102 01 0101 00 =SUMIFS(B2:B5,D2:D5,A7,E2:E5,"<"&A8) A7 = 0101 and A8=00 The IDs are formatted as text (to keep the leading zeroes). The equation is currently giving me 10 but it should be 9. When I change the second criteria to equals A8 it works and gives me 1. I've also made IF equations that check A7 & A8 against the First 4 & Last 2 columns and they behave as they should. This is only happens in the SUMIFS equation. Any ideas? Thanks Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumifs & Not Like | Excel Discussion (Misc queries) | |||
Sumifs | Excel Discussion (Misc queries) | |||
SUMIFS and OR | Excel Discussion (Misc queries) | |||
SUMIFS | Excel Discussion (Misc queries) | |||
SUMIFS and OR | Excel Worksheet Functions |